/* ORI FIPS Crosswalk cleaning .do file
Files used: ORI_FIPS_CROSSWALK.dta
Files created: ORI_FIPS_CROSSWALK_clean.dta
Programs used: clean_ORI.do
*/
********************************************************************************

** Clean ORI_FIPS_CROSSWALK

use "Raw Data/NIBRS/Crosswalk_Data/ORI_FIPS_CROSSWALK.dta", clear

*drop missing ORIs (-1)
drop if ori9 == "-1"

*keep relevant variables
keep ori9 fips

save "Raw Data/NIBRS/Crosswalk_Data/ORI_FIPS_CROSSWALK_clean.dta", replace
